package org.jsola.hr.dao;

import org.apache.ibatis.annotations.Param;
import org.jsola.hr.entity.SocProgDO;
import org.jsola.hr.query.SocProgQuery;
import org.jsola.hr.vo.SocProgListVO;
import org.jsola.orm.mapper.IJsolaMapper;
import org.springframework.stereotype.Repository;

import java.util.List;


/**
 * 参保方案表
 *
 * @author zhr
 */
@Repository("hrSocProgDAO")
public interface ISocProgDAO extends IJsolaMapper<SocProgDO> {

    /**
     * 分页查询参保方案相关
     * @param socProgQuery
     * @param siteId
     * @return
     */
    List<SocProgListVO> selectSocProgRelationList(@Param("socProgQuery") SocProgQuery socProgQuery, @Param("siteId") String siteId);

    /**
     * 查询参保方案表相关
     * @param socProgQuery
     * @param siteId
     * @return
     */
    List<SocProgListVO> listAllRelation(@Param("socProgQuery") SocProgQuery socProgQuery, @Param("siteId") String siteId);

    /**
     * 查询某参保方案使用人数
     * @param progId
     * @return
     */
    Integer selectCountByProgId(@Param("progId")String progId);
}

